PowerProtect | DDBMA standalone backup of SQL Always On database (AAG) fails

Summary: Data Domain DD Boost for Microsoft Applications (DDBMA) standalone backup of SQL Always On Availability Group (AAG) database fails

Acest articol se aplică pentru Acest articol nu se aplică pentru Acest articol nu este legat de un produs specific. Acest articol nu acoperă toate versiunile de produs existente.

Symptoms

Backups appear to run successfully but the stored procedure (master.dbo.emc_run_backup) reports a failure stating the following events:

Error message:

Successfully converted from group id to AG name.

149283:ddbmsqlsv: Start secondary backup job failed. host: <hostname>. error: Setting notification event failed on host: <hostname>.
85942:ddbmsqlsv: Stopping Federated backup - No jobs were started successfully. Unable to complete the federated backup.


 

Cause

The SQL Server agent job runs under the context of the user associated with the SQL Server Agent service. This user account had all necessary permissions (local admin on SQL server, full Windows Management Instrumentation (WMI) permissions per the Microsoft App Agent guide). The backup also works when run from the SQL Server Management Studio (SSMS) Plugin logged in with this user (associated with the SQL server agent service).

When the backup user is not a local administrator, they lack the required WMI privileges. This explains why backups succeed on the UI that uses the logged-in user's account, but fails in SQL, which uses the SQL service account.

Resolution

Confirm that the user is in the local administrator's group and add the SQL Service Account if needed. Verify Log on as a batch job or Log on as a service privileges, usually granted from local admin status; add manually if absent. If issues remain, restart the SQL service or reboot the server to fully apply local admin privileges.

Produse afectate

PowerProtect App Direct, PowerProtect Software
Proprietăți articol
Article Number: 000192006
Article Type: Solution
Ultima modificare: 07 oct. 2025
Version:  4
Găsiți răspunsuri la întrebările dvs. de la alți utilizatori Dell
Servicii de asistență
Verificați dacă dispozitivul dvs. este acoperit de serviciile de asistență.